[dbo].[BAEEventSetupAddQuestionChoice]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEEventSetupAddQuestionChoice

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@id	int	4
@answerID	varchar(8)	8
@answer	varchar(64)	64

SQL Script

create procedure [dbo].[BAEEventSetupAddQuestionChoice] @id int,
     @answerID varchar(8),
     @answer varchar(64) as
EXEC BAEEventSetupRemoveQuestionChoice @id, @answerID;

    INSERT INTO EventSetupQuestionChoice (EventSetupQuestionChoiceID, EventSetupQuestionID, Answer)
    VALUES (@answerID, @id, @answer);

GO

Uses

[dbo].[EventSetupQuestionChoice]
[dbo].[BAEEventSetupRemoveQuestionChoice]
dbo